﻿CREATE VIEW [dbo].[ASMS_V_PackageInstance]
	AS 
SELECT PINST.*,
	P.Code as PackageCode,
	P.[Name] as PackageName,
	C.[Name] as CustomerName
FROM ASMS_PackageInstance as PINST 
	left join ASMS_Package as P on P.Id = PINST.PackageId
	left join ASMS_Customer as C on C.Id = PINST.CustomerId
